Show All

Display or hide all values in a cell

1. Select the cells that contain hidden values or values you want to hide.
2. On the Format menu, click Cells, and then click the Number tab.
3. Do one of the following:

   Display hidden values in a cell

   In the Category list, click General to apply the default number format.

   To redisplay a date, a time, or values that have a specific number format, select the appropriate date, time, or number format on the Number tab.

   Hide all values in a cell

   1. In the Category list, click Custom.
   2. In the Type box, select the existing codes and press BACKSPACE.
   3. In the Type box, type ;;; (three semicolons).